1 <?php
2 session_start();
3 error_reporting(0);
4 include('includes/config.php');
5 if(strlen($_SESSION['alogin'])==0)
6 {
7 header('location:index.php');
8 }
9 else{
10 $pid=intval($_GET['pid']);
11 if(isset($_POST['submit']))
12 {
13 $pname=$_POST['packagename'];
14 $ptype=$_POST['packagetype'];
15 $plocation=$_POST['packagelocation'];
16 $pprice=$_POST['packageprice'];
17 $pfeatures=$_POST['packagefeatures'];
18 $pdetails=$_POST['packagedetails'];
19 $pimage=$_FILES["packageimage"]["name"];
20 $sql="update TblTourPackages set PackageName=:pname,PackageType=:ptype,PackageLocation=:plocation,PackagePrice=:pprice,PackageFetures=:pfeatures,PackageDetails=:pdetails where PackageId=:pid";
21 $query = $dbh->prepare($sql);
22 $query->bindParam(':pname',$pname,PDO::PARAM_STR);
23 $query->bindParam(':ptype',$ptype,PDO::PARAM_STR);
24 $query->bindParam(':plocation',$plocation,PDO::PARAM_STR);
25 $query->bindParam(':pprice',$pprice,PDO::PARAM_STR);
26 $query->bindParam(':pfeatures',$pfeatures,PDO::PARAM_STR);
27 $query->bindParam(':pdetails',$pdetails,PDO::PARAM_STR);
28 $query->bindParam(':pid',$pid,PDO::PARAM_STR);
29 $query->execute();
30 $msg="Package Updated Successfully";
31 }
32
33 ?>
34 <!DOCTYPE HTML>
35 <html>
36 <head>
37 <title>TMS | Admin Package Creation</title>
38 <meta name="viewport" content="width=device-width, initial-scale=1">
39 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
40 <meta name="keywords" content="Pooled Responsive web template, Bootstrap Web Templates, Flat Web Templates, Android Compatible web template,
41 Smartphone Compatible web template, free webdesigns for Nokia, Samsung, LG, SonyEricsson, Motorola web design" />
42 <script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
43 <link href="css/bootstrap.min.css" rel='stylesheet' type='text/css' />
44 <link href="css/style.css" rel='stylesheet' type='text/css' />
45 <link rel="stylesheet" href="css/morris.css" type="text/css"/>
46 <link href="css/font-awesome.css" rel="stylesheet">
47 <script src="js/jquery-2.1.4.min.js"></script>
48 <link href='//fonts.googleapis.com/css?family=Roboto:700,500,300,100italic,100,400' rel='stylesheet' type='text/css'/>
49 <link href='//fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
50 <link rel="stylesheet" href="css/icon-font.min.css" type='text/css' />
51 <style>
52 .errorWrap {
53 padding: 10px;
54 margin: 0 0 20px 0;
55 background: #fff;
56 border-left: 4px solid #dd3d36;
57 -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
58 box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
59 }
60 .succWrap{
61 padding: 10px;
62 margin: 0 0 20px 0;
63 background: #fff;
64 border-left: 4px solid #5cb85c;
65 -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
66 box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
67 }
68 </style>
69
70 </head>
71 <body>
72 <div class="page-container">
73 <!--/content-inner-->
74 <div class="left-content">
75 <div class="mother-grid-inner">
76 <!--header start here-->
77 <?php include('includes/header.php');?>
78
79 <div class="clearfix"> </div>
80 </div>
81 <!--heder end here-->
82 <ol class="breadcrumb">
83 <li class="breadcrumb-item"><a href="index.html">Home</a><i class="fa fa-angle-right"></i>Update Tour Package </li>
84 </ol>
85 <!--grid-->
86 <div class="grid-form">
87
88 <!---->
89 <div class="grid-form1">
90 <h3>Update Package</h3>
91 <?php if($error){?><div class="errorWrap"><strong>ERROR</strong>:<?php echo htmlentities($error); ?> </div><?php }
92 else if($msg){?><div class="succWrap"><strong>SUCCESS</strong>:<?php echo htmlentities($msg); ?> </div><?php }?>
93 <div class="tab-content">
94 <div class="tab-pane active" id="horizontal-form">
95
96 <?php
97 $pid=intval($_GET['pid']);
98 $sql = "SELECT * from TblTourPackages where PackageId=:pid";
99 $query = $dbh -> prepare($sql);
100 $query -> bindParam(':pid', $pid, PDO::PARAM_STR);
101 $query->execute();
102 $results=$query->fetchAll(PDO::FETCH_OBJ);
103 $cnt=1;
104 if($query->rowCount() > 0)
105 {
106 foreach($results as $result)
107 { ?>
108
109 <form class="form-horizontal" name="package" method="post" enctype="multipart/form-data">
110 <div class="form-group">
111 <label for="focusedinput" class="col-sm-2 control-label">Package Name</label>
112 <div class="col-sm-8">
113 <input type="text" class="form-control1" name="packagename" id="packagename" placeholder="Create Package" value="<?php echo htmlentities($result->PackageName);?>" required>
114 </div>
115 </div>
116 <div class="form-group">
117 <label for="focusedinput" class="col-sm-2 control-label">Package Type</label>
118 <div class="col-sm-8">
119 <input type="text" class="form-control1" name="packagetype" id="packagetype" placeholder=" Package Type eg- Family Package / Couple Package" value="<?php echo htmlentities($result->PackageType);?>" required>
120 </div>
121 </div>
122
123 <div class="form-group">
124 <label for="focusedinput" class="col-sm-2 control-label">Package Location</label>
125 <div class="col-sm-8">
126 <input type="text" class="form-control1" name="packagelocation" id="packagelocation" placeholder=" Package Location" value="<?php echo htmlentities($result->PackageLocation);?>" required>
127 </div>
128 </div>
129
130 <div class="form-group">
131 <label for="focusedinput" class="col-sm-2 control-label">Package Price in USD</label>
132 <div class="col-sm-8">
133 <input type="text" class="form-control1" name="packageprice" id="packageprice" placeholder=" Package Price is USD" value="<?php echo htmlentities($result->PackagePrice);?>" required>
134 </div>
135 </div>
136
137 <div class="form-group">
138 <label for="focusedinput" class="col-sm-2 control-label">Package Features</label>
139 <div class="col-sm-8">
140 <input type="text" class="form-control1" name="packagefeatures" id="packagefeatures" placeholder="Package Features Eg-free Pickup-drop facility" value="<?php echo htmlentities($result->PackageFetures);?>" required>
141 </div>
142 </div>
143
144
145 <div class="form-group">
146 <label for="focusedinput" class="col-sm-2 control-label">Package Details</label>
147 <div class="col-sm-8">
148 <textarea class="form-control" rows="5" cols="50" name="packagedetails" id="packagedetails" placeholder="Package Details" required><?php echo htmlentities($result->PackageDetails);?></textarea>
149 </div>
150 </div>
151 <div class="form-group">
152 <label for="focusedinput" class="col-sm-2 control-label">Package Image</label>
153 <div class="col-sm-8">
154 <img src="pacakgeimages/<?php echo htmlentities($result->PackageImage);?>" width="200"> <a href="change-image.php?imgid=<?php echo htmlentities($result->PackageId);?>">Change Image</a>
155 </div>
156 </div>
157
158 <div class="form-group">
159 <label for="focusedinput" class="col-sm-2 control-label">Last Updation Date</label>
160 <div class="col-sm-8">
161 <?php echo htmlentities($result->UpdationDate);?>
162 </div>
163 </div>
164 <?php }} ?>
165
166 <div class="row">
167 <div class="col-sm-8 col-sm-offset-2">
168 <button type="submit" name="submit" class="btn-primary btn">Update</button>
169 </div>
170 </div>
171
172
173
174
175
176 </div>
177
178 </form>
179
180
181
182
183
184 <div class="panel-footer">
185
186 </div>
187 </form>
188 </div>
189 </div>
190 <!--//grid-->
191
192 <!-- script-for sticky-nav -->
193 <script>
194 $(document).ready(function() {
195 var navoffeset=$(".header-main").offset().top;
196 $(window).scroll(function(){
197 var scrollpos=$(window).scrollTop();
198 if(scrollpos >=navoffeset){
199 $(".header-main").addClass("fixed");
200 }else{
201 $(".header-main").removeClass("fixed");
202 }
203 });
204
205 });
206 </script>
207 <!-- /script-for sticky-nav -->
208 <!--inner block start here-->
209 <div class="inner-block">
210
211 </div>
212 <!--inner block end here-->
213 <!--copy rights start here-->
214 <?php include('includes/footer.php');?>
215 <!--COPY rights end here-->
216 </div>
217 </div>
218 <!--//content-inner-->
219 <!--/sidebar-menu-->
220 <?php include('includes/sidebarmenu.php');?>
221 <div class="clearfix"></div>
222 </div>
223 <script>
224 var toggle = true;
225
226 $(".sidebar-icon").click(function() {
227 if (toggle)
228 {
229 $(".page-container").addClass("sidebar-collapsed").removeClass("sidebar-collapsed-back");
230 $("#menu span").css({"position":"absolute"});
231 }
232 else
233 {
234 $(".page-container").removeClass("sidebar-collapsed").addClass("sidebar-collapsed-back");
235 setTimeout(function() {
236 $("#menu span").css({"position":"relative"});
237 }, 400);
238 }
239
240 toggle = !toggle;
241 });
242 </script>
243 <!--js -->
244 <script src="js/jquery.nicescroll.js"></script>
245 <script src="js/scripts.js"></script>
246 <!-- Bootstrap Core JavaScript -->
247 <script src="js/bootstrap.min.js"></script>
248 <!-- /Bootstrap Core JavaScript -->
249
250 </body>
251 </html>
252 <?php } ?>
